UPDATE [<Owner>].[<Table>]
SET
<If Loop>
   <IsNotIdentity>
   <And>
   <IsNumber>
     <SF[,]>[<Field>] = <>
   <IsNotIdentity>
   <And>
   <IsNotNumber>
     <SF[,]>[<Field>] = '<>'
</If Loop>
WHERE
<If Loop>
   <IsPKey>
   <And>
   <IsNumber>
     <SF[,]>[<Field>] = <>
   <IsPKey>
   <And>
   <IsNotNumber>
     <SF[,]>[<Field>] = '<>'
</If Loop>
<If Loop>
   <IsNotPKey>
   <And>
   <IsIdentity>
   <And>
   <IsNumber>
     <SF[,]>[<Field>] = <>
   <IsNotPKey>
   <And>
   <IsIdentity>
   <And>
   <IsNotNumber>
     <SF[,]>[<Field>] = '<>'
</If Loop>
<If Loop>
   <IsNotIdentityCount>
   <And>
   <IsNotPKeyCount>
   <And>
   <IsNotText>
   <And>
   <IsNotNText>
   <And>
   <IsNotXML>
   <And>
   <IsNumber>
     <SF[,]>[<Field>] = <>
     <ExitLoop>
   <IsNotIdentityCount>
   <And>
   <IsNotPKeyCount>
   <And>
   <IsNotText>
   <And>
   <IsNotNText>
   <And>
   <IsNotXML>
   <And>
   <IsNotNumber>
     <SF[,]>[<Field>] = '<>'
     <ExitLoop>
</If Loop>


